Working with Tier Tables

A Tier Scheme is represented in Loyalty as a table with one or more rows, and with one or more columns. This table is referred to as the Tier Table.

Each row in the Tier Table corresponds to a Tier (see Working with Tiers for more information). For example, if your loyalty program has Base, Silver, and Gold Tiers, you would have three rows in your Tier Table, going from the lowest Tier on the top row to the highest Tier on the bottom row.

Each column in the Tier Table corresponds to a condition or threshold required for a Member to achieve that Tier. These conditions are expressed as Basic Tier Rules (see Working with Basic Tier Rules for more information). A Member must satisfy all conditions across all columns to achieve a given Tier. That is, multiple columns are joined with an AND logical operator.

A single Tier Scheme can have one or more Tier Tables defined within it. Each Tier Table defined within a Tier Scheme is governed by its own Effectivity Period and Status, which controls when that Tier Table is considered live and actively in use.

For example, let's say a client has a Tier Table for the current year with a set of Metric thresholds needed to attain each Tier , but the thresholds are going to change next year. The client could simply define another Tier Table for the upcoming year with the new Metric thresholds. Each Tier Table has its own expiration period, so the first Tier Table could be set to expire at midnight on December 31, with the new Tier Table then taking effect immediately on January 1.

Note: As a best practice, you should not define multiple Tier Tables with "overlapping" effectivity; you should have only one Tier Table active at a time. Likewise, be careful not to allow any gaps in effectivity. In the event that the evaluation date for a Member's Tier assignment does not fall under the effectivity period of any Tier Table, the first published Tier Table on the Base Rules tab will be considered as the effective one.

Tiers are always defined at a Tier Scheme level, meaning that if you have multiple Tier Tables defined in a Tier Scheme, all the Tier Tables will have the same set of Tiers (i.e., rows). However, the conditions for achieving those Tiers (i.e., columns) can vary from one Tier Table to another.

For more details on how to search for a Tier Table, see Search for a Tier Table.

Create a Tier Table Edit Tier Table Properties Publish a Tier Table